package com.itheima.mapper;

import com.itheima.pojo.Article;
import com.itheima.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ArticleMapper {
    //增加文章
    @Insert("insert into article(title, content, cover_img, state, category_id, create_user, create_time, update_time)" +
            " VALUES(#{title},#{content},#{coverImg},#{state},#{categoryId},#{createUser},#{createTime},#{updateTime})")
    void add(Article article);

    //根据条件查询文章列表
    List<Article> list(Integer userId, Integer categoryId, String state);

    //获取文章详情
    @Select("select * from article where id=#{id}")
    Article detail(Integer id);

    // 更新文章
    @Update("update article set title=#{title},content=#{content},cover_img=#{coverImg},state=#{state},category_id=#{categoryId} ,update_time=now()" +
            "where id=#{id}")
    void update(Article article);

    // 根据id删除文章
    @Delete("delete from article where id=#{id}")
    void delete(Integer id);

    @Select("select * from article")
    List<Article> articleList();

    @Select("select * from user where id=#{id}")
    User user(Integer id);

}
